Release 10.1A: OpenEdge Development:
Progress 4GL Reference

ISO-DATE function

Returns a character representation of a DATE, DATETIME , or DATETIME-TZ that conforms to the ISO 8601 standard for date/time representations.

Note: These formats are equivalent to the XML Schema date and dateTime formats.

Syntax

ISO-DATE ( expression )

expression

An expression that evaluates to a DATE, DATETIME or DATETIME-TZ.

The ISO-DATE function returns the character string in the standard ISO format of the data type. Table 36 lists the standard ISO formats for each data type.

Table 36: Standard ISO formats 

Data type	ISO format
DATE	YYYY-MM-DD
DATETIME	YYYY-MM-DDTHH:MM:SS.SSS
DATETIME-TZ	YYYY-MM-DDTHH:MM:SS.SSS+HH:MM

See also

DATE function, DATE-FORMAT attribute, DATETIME function, DATETIME-TZ function, DAY function, ETIME function, MONTH function, MTIME function, NOW function, TIME function, TIMEZONE function, TODAY function, WEEKDAY function, YEAR function, YEAR-OFFSET attribute